Oracle Analysis Server

To connect to Oracle 11gR2 cubes you need to have installed Simba provider for Oracle M4OXmlaWebService (www.simba.com). This is the same one used to connect MS Excel to Oracle cubes.

If you have it installed select button:

·             user defined connections

 

Dialog will appear.

 

 

Server type Data provider leave as it is because they are the same as for Microsoft.

Set:

 

·         Analysis name – this one will be used on tab of selected analysis

·         Connection name – used to differ connections

·         Server –address of your Simba provider like

http://XXX.XXX.XX.XXX:YYYY/M4OXmlaWebService/

·         Database – just press arrow and wait application to brows databases

·         Cube – just press arrow and wait application to brows cubes

 

If your connection requires user name and password then uncheck integrated security checkbox and enter appropriate user name and password.